��R
�0-%m�&��.��2�K��M�	eW�[7`]�	gr�i��l;�J
K�m���*W���Tg���)J����Թ?/�ͽD&���Ko�/01 Fields Options
    The following Pulldown Menu items are available from the
Fields Main Menu option:

    - Selected Database: The name of the currently selected
      database is displayed.

    - Viewing: If specific Fields were selected for viewing in
      the Field Selection Screen, "Selected Fields" is dis-
      played, otherwise "All Fields" is displayed.

    - Current Field: The name of the Field, or the Expression,
      of the currently highlighted column in the Browse window
      is displayed.

    - Field Selection Screen: Multi-Select Interface for selec-
      tion of Fields and entering of Expressions to be shown in
      the Browse window data columns.

    - Cut/Delete Column: Remove the currently highlighted
      column in the Browse window.

    - Paste Column: Insert the last with "Cut/Delete Column"
      deleted Browse column before the currently highlighted
      Browse column.

    - Insert Column: Display a picklist of all available
      Fields/Expressions. Select one, and a column for this
      Field is instantly inserted before the current Browse
      column.

    - Lock # of Fields: Specify the number of data columns on
      the left side of the Browse Window to be "locked" or
      "frozen".

    - Column Options: Specify a Custom Column Heading and
      Column Width for the currently highlighted Column in the
      Browse Window. Optionally specify a Picture, When, and
      Valid Clause for Editing of the Column Content.

    - Create/Modify Structure: View/Create/Modify/Print data-
      base structure. Hot-key from Field Selection Screen:
      <Alt-M>.

    - FlexFile Pointer Field: Mark or UnMark the current Column
      as FlexFile Pointer Field.
/02 Field Selection
    The Field Selection Screen allows for Selection of Fields
from the current database, and of valid Expressions, to be
displayed as columns in the Browse Window. By default all
Fields of the current database are displayed in the left win-
dow. Selected Fields are displayed in the right window. The
current directory path is always displayed on row 3 left. The
current database name is displayed midscreen on line 3. The
key expression of the controlling index is displayed on the
left bottom side of the screen.

    If no Fields are selected, automatically all Fields will be
displayed as columns when proceeding to the Browse Window, in
the same order as displayed in the left window of the Field
Selection Screen.

    If Fields / Expressions are selected, only the selected
Fields will be displayed as columns when proceeding to the
Browse Window, in the order as listed in the right window of
the Field Selection Screen.

    <Enter> - adds the currently highlighted Field/Expression
in the left window to the right window. The same Field/Expres-
sion can be added more the once to the right window.

    <Esc> - clears the Field Selection Screen and displays
the Browse Window as specified by the selected Fields.

    <Del> - scans the list of selected Fields/Expressions in
the right window for a Field of the same name as the currently
highlighted Field in the left window. If found, the first oc-
currence of the selected Field is removed from the right win-
dow.

    <Ins> - allows to add any valid Expression to the left win-
dow of available Fields/Expressions. The Expression may be
based on a Field from the current or from a related database.
Examples: CDOW(StartDate), CMONTH(StartDate), CUSTOMER->Name.
The added Expression is inserted at the top of the picklist in
the left window.

    <Alt-E> - Re-edit a currently highlighted expression in the
Fields picklist.

    <F2> to <F9> - access Main Menu options.

    <Alt-F2> - clear the Field Selection Screen and proceed to
the Database Selection Screen.

    <Alt-F3>, <left> - clear the Field Selection Screen and
proceed to the Index File Selection Screen.

    <Alt-N> - rotate to the Field Selection Screen for the
database in the "Next" Select Area.

    <Alt-Minus> - rotate to the Field Selection Screen for the
database in the "Previous" Select Area.

    <Alt-H> - display a listing of keystrokes available from
the Field Selection Screen.

    <Alt-P> - toggle Index PreSelection ON or OFF.

    <Alt-A> - select All Fields/Expressions displayed in the
left window of Available Fields and copy them into the right
window.

    <Alt-K> - remove all currently selected Fields/Expressions
and clear the right window.

    <Alt-M> - proceed to the "Modify/Create Database Struc-
ture" screen for the current database.

    <Alt-X> - toggle the Open Mode of the current database
between SHARED and EXCLUSIVE. The current mode is shown to
the right on line 3.

    <Alt-Y> - allows changing from one directory to another
directory.

    <Alt-Z> - shell out to DOS. To return to the Field
Selection Screen, type EXIT on the DOS Prompt.

    <Character> - AutoSeek. The highlight bar in the left
window moves to the desired item as you type. The characters
entered are displayed midscreen on line 4. To clear the Seek
String, press <Ctrl-Backspace>.
/03 FileSpec
    For the database and index selection process, a FileSpec
can be specified. It may contain the wildcard characters "*"
and "?". The Default FileSpecs are derived from adding a "*"
in front of the Default Database / Index File Extensions as
entered in the GlobalSet Pulldown Menu options.

    Select the Database FileSpec option from the Database Pull-
down menu, or by pressing <Alt-F> from the Database Selection
Screen.

    Select the Index FileSpec option from the Index Pulldown
menu, or by pressing <Alt-F> from the Index Selection Screen.
/04 FlexFile Data Access
    If the current version of BroPlus was linked using the
FlexFile API interface, it is sensitive to FlexFile pointers
contained in character type database fields.

    Without further customization, if an attempt is made to
"edit" a FlexFile pointer field, and a file in the same direc-
tory, with the same root name as the current database and a
".DBV" extension exists, the Data pointed to by the pointer
field are displayed. If such a file does NOT exist, the message
"FlexFile Data Type: Undefined" is displayed.

    To custom tailor Flex Data access in BroPlus, two options
are available:

    - Specify a Non-Default Flex file name to be linked to the
      current database (AreaSet, option "FlexFile Link"). Any
      valid DOS filename and extension can be used. If a file
      of that name does not exist you have the option to create
      it. To store FlexFile data for a whole system of data-
      bases together, and to save file handles, you may link
      several databases to one common Flex file.
         If a filename is entered in this option, Flex data are
      retrieved and stored in this file instead of in the file
      with the default name and extension.

    - Link a specific Field Column to the currently linked
      Flex file (Fields Menu option "FlexFile Pointer Field").
      Confirm the Prompt to Mark or Unmark the entire current
      Field Column as FlexFile pointers. By default only if a
      field's content is a valid FlexFile pointer, it is recog-
      nized and treated as Flex Data. Marking an entire column
      as FlexFile pointers allows to create Flex Data of any
      type, even if the pointer field is empty.

    If a Column is marked as FlexFile pointer field, Flex Memos
can be printed to the printer or sent to a file using the
Command Option "LIST TO PRINT", "specific Memo Field".

    The current version of BroPlus supports FlexFile data of
type Character (Memos), Clipper Arrays, Date, Logical, and
Numeric. Support for Clipper and Class(y) Objects is being con-
sidered.
/05 FlexFile Data Types
    The current version of BroPlus supports FlexFile data of
type Character (Memos), Clipper Arrays, Date, Logical, and
Numeric. Support for Clipper and Class(y) Objects is being con-
sidered.

    BroPlus allows retrieval of FlexFile data of any of the
supported data types by pressing <Enter> on an existing pointer
field. The data is displayed in the format appropriate to the
data type.

    To allow Creation of FlexFile data from the BroPlus Data-
base Browse Screen, the Field in the current Browse column must
be marked as FlexFile pointer field (see: Fields Options).

    To create FlexFile data of a specific type, press <Enter>
on the empty FlexFile pointer field. A Picklist of data type
choices pops up:

    - Create Memo: Enter flexible length text into the Memo
      editor. Save with <Ctrl-W>, or Cancel with <Esc>.

    - Import DOS file: Specify the name of a file to store the
      content of into the Flex file. The file will be stored as
      Character type, but there is no restriction on the type
      or size of the file, e.g. binary files or graphic images
      are perfectly legal.

    - Array: Enter the number of elements for the first dimen-
      sion of the Clipper array to be created, and an editable
      Browse window of those elements pops up. From this Array
      Browse window, any number of dimensions can be added.

    - Date, Logical: Enter a single date or logical value to be
      stored in the Flex file.

    - Numeric: To customize the precision of the number, speci-
      fy number of decimals for entry of the number, then enter
      a single number to be stored in the Flex file.
/06 FlexFile: Clipper Arrays
    BroPlus allows creation, retrieval, viewing, editing, ex-
    pansion, shrinking and saving of Clipper 5.0 multidimen-
    sional arrays stored in a Flex file. There is no limit on
    the number of dimensions you may work with.

    - Creation: Press <Enter> on an empty FlexFile pointer
      field, select "array", then enter number of elements for
      the first dimension.

    - Retrieval and Viewing: Press <Enter> on a non-empty Flex-
      File pointer field. If it contains reference to a stored
      Clipper array, the Array Browse Window pops up, display-
      ing the elements of the first dimension. Elements con-
      taining a subarray show the { ... } symbol. Press <Enter>
      on the symbol to display the next dimension.

    - Editing: In the Array Browse Window, if an element is of
      type Character, Date, Logical, Numeric, or NIL, press
      <Enter> to edit its content. Enter a valid expression of
      any of those data types. Strings must be put in quotes,
      invalid entry is rejected.

      Press <Alt-M> to edit long character strings in a Memo-
      Edit type window instead of a one-line field.

         To create a subarray in place of an element, enter
      'array(<n>)' where <n> is the number of elements in the
      subarray, or enter a literal array, e.g. { "One","Two" }.
      An expression returning a value of type Array would also
      be valid, e.g. 'dbstruct()' or 'directory("*.DBF")'.

    - Expansion and Shrinking: Press <Ins> to Insert a new ele-
      ment before the element currently under the Browse cur-
      sor. Press <Down arrow> from the last element of the ar-
      ray to Append an element to the end of the array. Press
      <Del> to Delete the element currently under the Browse
      cursor and shrink the array by 1 element.

    - Saving: Pressing <Esc> from any array level takes you
      back to the previous dimension. Pressing <Esc> from the
      first dimension takes you back to the Database Browse
      Window. If any editing was done on the array, you are
      prompted whether to Save or Cancel the changes before re-
      turning to the Database Browse Window.
/07 FlexFile: Data Deletion
    To delete the data associated with a FlexFile Memo or
FlexFile pointer field, position the Browse cursor over the
cell containing the pointer and press <Alt-BackSpace>. You are
prompted whether you wish to Erase the FF data, or Cancel the
operation. Once FlexFile data are erased they can't be restored

FlexFile API interface:

    For FlexFile data deletion involving more than one record,
    use the REPLACE command option. Special cases are:

    Data deletion before issuing a PACK or ZAP command.

    Before a PACK:
  REPLACE <cFlexPtr> WITH v_delete( <cFlexPtr> ) FOR DELETED()

    Before a ZAP:
  REPLACE <cFlexPtr> WITH v_delete( <cFlexPtr> )

    <cFlexPtr> is the Field Name of the FlexFile pointer field
    and must be marked as such under "Fields" options.

FlexFile RDD interface:

    PACKing and ZAPping work seamlessly and do not require
    special handling of the memo data.
/08 GlobalSet
    The Pulldown Menu choices in the Main Menu option
"GlobalSet" allow configuration of BroPlus to the specific re-
quirements of the user. The Global Settings can be saved, and
will then automatically be restored at startup of each BroPlus
session. The following Menu choices are offered:

    - Database Driver: Select the Database Driver you want to
      work with. Any database opened after the selection will
      be using the new Database Driver (and maintain it until
      closed).

    - Default Database/Index Extension: Enter the File extens-
      ions specific to your database system.

    - Default Open Mode: Toggle whether databases should ini-
      tially be opened in SHARED or EXCLUSIVE mode.

      Note: Default EXCLUSIVE Mode should ONLY be selected on
      Standalone Computers, NEVER on Network Workstations. To
      toggle to Default EXCLUSIVE Mode, "Modify" must be enab-
      led (see below).

    - Enable/Disable Modify: Toggle Ability to Modify Data.
      If DISABLED: Only Browsing/Viewing of Data is accessible.
      If ENABLED:  All of BroPlus's Features are accessible.
      Depending on the way BroPlus was installed the entry of a
      password may be required to toggle Modify to "ENABLED".

    - Protected/Immediate Edit: If "Protected Edit" is speci-
      fied the <Enter> Key MUST be pressed in order to edit the
      currently highlighted cell in the Browse Window. Network:
      The current record is locked when pressing <Enter>, and
      remains locked until Editing of this cell is terminated.

      If "Immediate Edit" is specified you may type directly
      into the currently highlighted cell, and pressing of the
      <Enter> Key is NOT required. Network: The current record
      is NOT locked during Editing, and is only locked moment-
      arily while the data is REPLACEd.

      Delete/Recall Record: If "Protected Edit" is specified,
      pressing the <Del> key will display a Prompt before Mark-
      ing/Unmarking the current record. If "Immediate Edit" is
      specified, NO prompt is displayed, Marking/Unmarking
      happens instantly.

    - Cell/Row/Column Edit: After Editing of a Cell in the
      Browse Window and completing the Edit with <Enter>:

      - If "Cell Edit" is specified the highlight bar in the
        Browse Window will remain on the same cell.

      - If "Row Edit" is specified the highlight bar will pro-
        ceed to the cell to the right on the same data row.

      - If "Column Edit" is specified the highlight bar will
        proceed to the cell below on the same data column.

    - Softseek On/Off: Toggle Softseek ON or OFF.

    - Preselect Indexes: toggle Index PreSelection ON or OFF.

      OFF: all index files in the current directory with the
      default extension will be displayed in the left window of
      the Index File Selection Screen.

      ON: only index files with matching key expressions
      (referencing fields from the current database only) will
      be displayed.

    - Sound On/Off: Toggle Sound On or Off, to signal success,
      failure, or completion of an operation.

    - Default Directories: A Default Data Directory can be spe-
      cified where BroPlus will change to at Startup.
         View files can be saved to / restored from any direc-
      tory. To better organize your View files you may specify
      a Default View Directory where View files will be saved
      to / restored from. If a view is restored from the
      Command Line, and NO path is specified with the view file
      name, the Default View Directory will be searched for a
      matching view file name.

    - Screen Mode: Toggle between 25|43|50 lines per screen.

    - Split Screen / Zoom: Toggle the ability to view two data-
      bases at once on the screen, and full screen Browse mode.

    - Move Screen Border: If Split screen mode is selected,
      move the border between the two Browse windows up or down

    - Other: Display more GlobalSet options.

    - Save Global Settings: Save current global settings to a
      file called "BRO.INI" in the directory specified with the
      Environment Variable "BRO". At startup all saved global
      settings are automatically reinstated.

    - Browse Column Buffer Size: Specify the number of columns
      to be used for a TBrowse buffer area. The Default value
      is 12, values from 1 to 64 can be entered.
      A small buffer size speeds up vertical Browse movement,
      but causes more frequent slight delays in horizontal
      Browse movements whenever a Browse buffer boundary is
      encountered.

    - Default Memo Width: Initial memo width setting when
      opening a table.

    - Auto-Alias ON/Off: With Auto-Alias ON, the database root
      name is automatically used as Alias name for opening
      (USE) of the database.
      With Auto-Alias OFF, when selecting a database for USE,
      you are prompted to enter an Alias name BEFORE the data-
      base is opened.
      Auto-Alias OFF is particularly useful if your database
      has an associated auto-opening structural or production
      index that contains tags using a non-default Alias name
      in the key expression.

    - Epoch: Specify the base year of a 100-year period in
      which all dates containing only two year digits are
      assumed to fall. The default base year is 1900.

    - Date Format: Select your country-specific Date Format
      from among 14 choices (both with and without the century
      digits.

    - Printer Codes: Enter starting and ending Printer Control
      Codes to be used for printing of Browse columns and data-
      base structures. Use DBase syntax, e.g.:  chr(27)+"(s16H"

    - Dirty-Read is On/Off: If the SIx Driver is selected,
      you can toggle the option to either ensure that Data are
      always up-to-date when doing sequential file processing
      with index files open (Dirty-Read OFF), or to turn auto-
      matic file refresh off during such operations (Dirty-Read
      ON), thereby speeding up processing considerably in Net-
      work Environments.

    - Default MemoBlockSize: Specify the default Block size for
      .FPT or .SMT Memo fields if the SIx Driver is used.
      The value must be between 16 and 1024.
/09 GOTO Entry
    The GOTO entry window may be accessed from the Record Main
Menu option, or from the Browse Screen by pressing <Alt-G>.
Simply enter the record number of the target record. The Browse
Screen will refresh, and the highlight bar will sit on the
target record.

Note: If a Range/Filter is specified for the Browse Window,
GOTO will respect the Range and Filter condition and display a
message if the target record is outside the range or does not
meet the condition.
/10 Help on Help
    Context Sensitive Help is available from everywhere in
BroPlus by simply pressing the <F1> key. While you are on the
Menu System, <F1> gives summary information on the Menu choices
below the current Main Menu option. For detailed information
about a particular Pulldown Menu item, press <F1> after you
made your Menu Selection.

    The "Help" Main Menu option offers the following Pulldown
Menu choices:

  - Browse Window Help: Detailed Listing of all Cursor Movement
    Keys and Action Keys (Hot Keys) available from any Browse
    Window.

  - Help on Help: This Help Screen

  - Help Index: List of all Help Topics in alphabetical Order.
    Select a Topic to view Topic Specific Information.

  - Command Line Parameters: Optional Parameters to be passed
    to BroPlus from the DOS Prompt.

  - Expression Evaluator: Pseudo-Dot-Prompt interface for
    interactive evaluation of Clipper expressions. Simply enter
    an expression to be evaluated, e.g. TIME(), and the result
    will be displayed instantly. Execution of Clipper COMMANDS
    is not supported.

    WARNING: It is recommended to avoid entering expressions
    that change the status of databases or other system data.
    E.g. you should NOT enter any of the DB...() functions or
    similar functions. BroPlus keeps track of all database and
    system information in a data dictionary stored in memory.
    However, most changes caused by the Expression Evaluator
    are not recognized by this internal data dictionary, and
    are likely to cause erratic behaviour or system crashes.
    The BroPlus menu system and interface provide everything
    necessary to manipulate database and system information,
    and there should be no need to (mis)use the Expression
    Evaluator for such purposes.
    This option is also available from the Browse window by
    pressing <Alt-F1>.

  - Calculator: Full-featured Popup Calculator, can be popped
    up from anywhere at any time using the Hot-key <Ctrl-F1>.

    If popped up from a numeric cell in the Browse screen, or
    from a numeric GET entry field, the current number is
    imported into the calculator. By pressing <Ctrl-Enter>,
    results from calculations can be pasted into numeric Browse
    cells or GET entry fields.

    Calculator keystroke help is available by pressing <H>
    while in the calculator.

  - Copyright: Copyright Information about BroPlus.
/11 Immediate/Protected Edit
    In the GlobalSet Menu options, you can specify whether Edit
within Browse Window should be PROTECTED or IMMEDIATE.

PROTECTED EDIT: The <Enter> Key MUST be pressed in order to
    edit the currently highlighted cell in the Browse Window.
    Network: The current record is locked when pressing
    <Enter>, and remains locked until Editing of this cell is
    terminated.

IMMEDIATE EDIT: You may type directly into the currently high-
    lighted cell, and pressing of the <Enter> Key is NOT
    required.
    Network: The current record is NOT locked during Editing,
    and is only locked momentarily while the data is REPLACEd.

Delete/Recall Record: If "Protected Edit" is specified, pres-
    sing the <Del> key will display a Prompt before Marking/
    Unmarking the current record. If "Immediate Edit" is speci-
    fied, NO prompt is displayed, Marking/Unmarking happens
    instantly.

/12 Incremental Seek
    Incremental Seek can be toggled from the AreaSet Main
Menu option, or by pressing <Alt-I> from the Browse Window.

    If Incremental Seek is ON: AutoSeek (Seek while you type)
inside the Browse Window is enabled. An Index File with a Char-
acter Type Key Expression must be in control for Incremental
Seek to be available. The key expression and the chars entered
are displayed on the bottom status bar of the Browse Screen.

    While in Incremental Seek Mode, use the <BackSpace> key for
"Decremental" Seek, <Ctrl-BackSpace> to clear the Seek String.
/13 Index Options
    The following Pulldown Menu options are displayed or selec-
table:

    - Selected Database: The name of the currently selected
      database is displayed.

    - Current Index: The physical index file number, total
      number of physical index files open in this work area,
      and name of the current index file are displayed.

    - Current Tag: The ordinal number of the current index
      order, total number of orders in the current work area,
      and tag name of the current order are displayed.

    - Key: If an index is in control, it's key expression is
      displayed, if not, the text "Natural Order" is displayed.

    - Index File Selection Screen: Multi-Select Interface for
      opening, selecting, and closing of index files.

    - Next/Previous Index: Go forwards/back to put the next or
      previous index/tag in control.

    - Tag Selection/Information: The Tag Browse window is dis-
      played, containing information for all tags of all index
      files in the current workarea. From this window, tags can
      be selected (including SET ORDER TO 0), added, deleted,
      modified and reindexed.

    - Index ScopeTop/Bottom: If the SIx Driver, HiPer-SIx, or
      Comix is chosen and an index or tag is in control, a Top
      and/or Bottom Scope value can be entered, to limit the
      index's/tag's scope for ALL operations of this index/tag.

    - Open Mode: Toggle the Open Mode of the current database
      between SHARED and EXCLUSIVE. For index creation (see
      below) it is recommended that the database be open in
      EXCLUSIVE mode.

    - Create Index File: Create a New Index or Tag, or modify
      an existing Index or Tag. Hot-key from Index File Select-
      ion Screen: <Alt-M>.

    - Verify Index File Integrity: verify if controlling Index
      File is up to date or corrupted. This option is available
      for the DBFNTX driver only.

    - Index PreSelection: toggle Index PreSelection ON or OFF.

    - Index FileSpec: Specify a FileSpec to be used for select-
      ion of Index files in the Index File Selection Screen.
      The FileSpec can contain the wildcard characters * and ?

    - Change Directory: Change to a specified drive/directory.
      Optionally choose from a Picklist of directories on a
      specified drive.

    - Shell to DOS: Shell out to DOS. To return to BroPlus type
      EXIT on the DOS Prompt.
/14 Index PreSelection
    Index Preselection can be toggled from the Index and
GlobalSet Main Menu options, or by pressing <Alt-P> from the
Browse Window, the Database Selection Screen, the Index Select-
ion Screen or the Field Selection Screen.

    Index PreSelection can be turned ON or OFF.

    OFF: all index files of the specified FileSpec in the
         current directory will be displayed in the left window
         of the Index File Selection Screen.

    ON:  only index files of the specified FileSpec, with
         matching key expressions (referencing fields from the
         current database only) will be displayed.
/15 Index ScopeTop/Bottom
    If the SIx Driver, HiPer-SIx, or Comix is chosen and an
index or tag is in control, a Top and/or Bottom Scope value can
be entered, to limit the index's scope for all operations of
this index or tag.

    The index scope entry window can be opened from the Index
Pulldown menu, or from the Browse window by pressing <Shift-F3>.

    This option is similar to the "Range" setting of the
AreaSet Menu option "Range & Filter" insofar as it also allows
specifying a beginning and / or ending value. While the "Range"
setting only limits the Browse window display, Index ScopeTop /
ScopeBottom puts new logical Top of File / End of File settings
in effect. Any global file operations will obey these index
boundaries.
/16 Index Selection
    The Index File Selection Screen allows opening of up to
seven index files for each open database. Index files avail-
able for selection are displayed in the left window, open
index files are displayed in the right window. Index files
from the current directory are displayed without path, index
files from other directories are displayed including path.
The current directory path is always displayed on row 3 left.
The current database name is displayed midscreen on line 3.
By default all files in the current directory with the speci-
fied FileSpec are displayed in the left window.

    On the right window, the controlling index is marked by
markers on both sides, which means: The Browse Screen that be-
longs to the database will be displayed in the order defined
by this index file (DBFNTX/DBFNDX only). The key expression of
the controlling index is displayed on the left bottom side of
the screen.

    <Enter> - adds the currently highlighted index file in the
left window to the right window and marks it as controlling
index. If the index file is already open in the right window
but not marked, <Enter> re-marks it as controlling index.

    <Esc> - clears the Index File Selection Screen and displays
the Browse Window belonging to the current database in the ord-
er specified by the controlling index. If no index files are
open or none is marked as controlling index, <Esc> displays the
Browse Window in order by record number.

    <Del> - scans the list of open index files in the right
window for a file of the same name as the currently highlighted
file in the left window. If found, the selected file is closed
and removed from the right window. If the deleted file was mar-
ked as controlling index file, no index file will be in control
and the database will be in order by record number.

    <Ins> - allows to add a file from another directory or
with an extension other than the FileSpec extension to the left
window of available index files. The added file is inserted at
the top of the picklist in the left window.

    <F2> to <F9> - access the Main Menu options.

    <Tab> or <Alt-O> - move the marker for the controlling in-
dex to the next file down in the right window. If the marker is
on the bottom file, <Tab> or <Alt-O> proceed to order by record
number (no controlling index, no marker visible). If no marker
is visible, <Tab> or <Alt-O> move the marker to the top index
file (DBFNTX/DBFNDX only).

    <Shift-Tab> - moves the marker for the controlling index
one file up (backwards) in the right window. If the marker is
on the top file, <Shift-Tab> proceeds to order by record number
(no controlling index, no marker visible). If no marker is vis-
ible, <Shift-Tab> moves it to the bottom file (DBFNTX/DBFNDX
only).

    <Ctrl-F3> - Open the Tag Selection/Information window for
the current work area.

    <Alt-F2>, <left> - clear the Index File Selection Screen
and proceed to the Database Selection Screen.

    <Alt-F4>, <right> - clear the Index File Selection Screen
and proceed to the Field Selection Screen.

    <Alt-N> - rotate to the Index Selection Screen for the
database in the "Next" Select Area.

    <Alt-Minus> - rotate to the Index Selection Screen for the
database in the "Previous" Select Area.

    <Alt-H> - display listing of keystrokes available from the
Index File Selection Screen.

    <Alt-F> - Specify / modify the FileSpec for Index File
Selection.

    <Alt-P> - toggle Index PreSelection ON or OFF. If OFF: all
index files in the current directory with the default extension
are displayed in the left window. If ON: only index files with
matching key expressions (referencing fields from the current
database only) are displayed.

    <Alt-A> - open All index files in the selection list (left
window) and display them in the right window. Mark the first
index in the list as controlling index. <Alt-A> is only avail-
able if index files in the left window were preselected (Index
Preselection ON).

    <Alt-K> - Close all currently open index files of the curr-
ent database and remove them from the right window.

    <Alt-M> - proceed to the "Modify/Create Index File" window.
If a file is marked as controlling index in the right window,
this file's path, name, expressions, and attributes are dis-
played in the window.

    <Alt-X> - toggle the Open Mode of the current database bet-
ween SHARED and EXCLUSIVE. The current mode is shown to the
right on line 3.

    <Alt-Y> - allows changing from one directory to another
directory. After the change to the new directory, the right
window will contain the same selected files as before. The left
window will display currently open files on top, followed by
all files of the current Index FileSpec in the new directory.

    <Alt-Z> - shell out to DOS. To return to the Index File
Selection Screen, type EXIT on the DOS Prompt.

    <Character> - AutoSeek. The Highlight Bar in the left
window moves to the desired item as you type. The characters
entered are displayed midscreen on line 4. To clear the Seek
String, press <Ctrl-Backspace>.

    <Ctrl-Enter> - verifies if controlling index file is up to
date. Scans the index file, for each key goes to the corre-
sponding record number in the database, evaluates the index
key expression on this record, compares to the key value in the
index file, and stops at the first error with a message in-
dicating whether no record was found or whether a key mismatch
occurred. If no error occurred, a "No problems found" message
appears. <Ctrl-Enter> is available for DBFNTX Driver only.
/17 Create Labels
    LABEL FORM is a Pulldown Menu item on the "Command" Main
Menu option. It allows to Print Labels using data from the
current database and a predefined Label Form file, for/while
a condition/range. The Label Form file (default extension .LBL)
can be created using Clipper's RL.EXE Report and Label Genera-
tor Utility.
    If Printer Codes are specified in the GlobalSet Menu Option
"Printer Control Codes", LABEL FORM will use these Codes for
the Printout.

Parameter entry fields:

    - LABEL FORM: Specify the path and file name of the Label
              Form file to use for the printing of Labels. On
              the file name entry field a Picklist of "*.LBL"
              files in the specified "path" directory pops up.
              Select an item from the Picklist, or press <Esc>
              on the Picklist and enter the Label Form file
              name into the field.
    - SAMPLE: Specify whether or not you want a Sample Printout
              of Labels with dummy data, to verify proper
              alignment of the Labels in your printer.
    - TO:     Press <Enter> to select between "PRINT" and
              "FILE", or press <Down arrow> to confirm the cur-
              rent "TO" selection.
              If "PRINT" is chosen, output is sent to the cur-
              rent default printer.
              If "FILE" is selected, enter the file name of the
              file output is being sent to. If the file name
              you specify exists already: Overwrite the file,
              Append to the file, or Cancel the operation.
    - SCOPE:  Press <Enter> to select between "ALL", "NEXT",
              and "REST", or press <Down arrow> to confirm the
              current scope. 
              If "ALL" (default) is chosen processing starts at
              top of file unless a "WHILE" expression is ent-
              ered.
              If "NEXT" or "REST" is chosen, or "ALL" with a
              "WHILE" expression, processing starts at the
              current record.
              If "NEXT" is selected, enter the number of re-
              cords to process starting at the current record.
              If "REST" is selected, all records from the cur-
              rent record until end of file are processed.
    - WHILE:  A "WHILE" clause usually requires an index to be
              in control. Enter a logical expression, and pro-
              cessing will continue as long as the expression
              evaluates to TRUE. Example: "AGE < 65".
              If a Range is specified for the current Browse
              Window, the beginning and ending values of the
              Range are automatically translated into a "WHILE"
              expression and offered as default.
    - FOR:    Enter a conditional expression, e.g.:
              ZIP = "90064". Only records meeting the "FOR"
              condition are included in the processing.
              If a Filter condition is specified for the cur-
              rent Browse Window, the Filter expression is
              automatically offered as default for the "FOR"
              condition.

FOR and WHILE clauses: The <F4> key can be pressed while on
    the entry field, to display a picklist of fields from the
    current database. The expression is validated, invalid
    entry is recognized and rejected.
/18 List to Print
    LIST TO PRINT is a Pulldown Menu item on the "Command" Main
Menu option. It allows to Print three types of lists:

    - A Columnar Listing of the CURRENT FIELD SELECTION as dis-
      played in the Browse Window.

    - A ONE(or more)-PAGE-PER-RECORD listing of the current
      Fields with a field name/field content pair on each line.
      This listing includes character type memo fields.

    - The Content of a specific MEMO FIELD or FlexFile Memo
      linked to the current database. To recognize a FlexFile
      pointer field, it must be marked as such in the "Fields"
      Main Menu option "FlexFile Pointer Field".

    All three types of listings are generated for/while a cond-
ition/range.

If the Current Field Selection is printed, the column headings
as displayed in the Browse Window are printed once at the
starting page of the List. If the Browse Window Column Headings
consist of two or more lines, only the first line of headings
is printed. For each record processed one row of data is prin-
ted.
    If the content of a Memo Field or Flex Memo is printed, the
Name of the Memo Field is printed on top of the Listing. For
each record processed the record number and, if an index is in
control, the key value is printed on top, followed by the Memo
Content for the specific record. The Memo Content is printed in
as many lines as needed. The Memo Line Width is determined by
the value of the AreaSet Menu option "Memo Width".
    If Printer Codes are specified in the GlobalSet Menu Option
"Printer Control Codes", all three types of listings will use
these Codes for the Printout.

Parameter entry fields:

    - LIST:   Press <Enter> to select between "Current Fields/
              Columnar", "One-Page-per-Record" and "Memo Field"
              or press <Down arrow> to confirm the current
              "LIST" selection.
              If "Memo Field" is selected, a Picklist of fields
              from the current database pops up. Select a Memo
              Field from the list, or press <Esc> on the Pick-
              list and enter the Memo Field name into the entry
              field. If the selected Field is NOT a Memo Field
              or a FlexFile Pointer Field marked as such, entry
              is rejected.
    - TO:     Press <Enter> to select between "PRINT" and
              "FILE", or press <Down arrow> to confirm the cur-
              rent "TO" selection.
              If "PRINT" is chosen, output is sent to the cur-
              rent default printer.
              If "FILE" is selected, enter the file name of the
              file output is being sent to. If the file name
              you specify exists already: Overwrite the file,
              Append to the file, or Cancel the operation.
    - SCOPE:  Press <Enter> to select between "ALL", "NEXT",
              and "REST", or press <Down arrow> to confirm the
              current scope. 
              If "ALL" (default) is chosen processing starts at
              top of file unless a "WHILE" expression is ent-
              ered.
              If "NEXT" or "REST" is chosen, or "ALL" with a
              "WHILE" expression, processing starts at the
              current record.
              If "NEXT" is selected, enter the number of re-
              cords to process starting at the current record.
              If "REST" is selected, all records from the cur-
              rent record until end of file are processed.
    - WHILE:  A "WHILE" clause usually requires an index to be
              in control. Enter a logical expression, and pro-
              cessing will continue as long as the expression
              evaluates to TRUE. Example: "AGE < 65".
              If a Range is specified for the current Browse
              Window, the beginning and ending values of the
              Range are automatically translated into a "WHILE"
              expression and offered as default.
    - FOR:    Enter a conditional expression, e.g.:
              ZIP = "90064". Only records meeting the "FOR"
              condition are included in the processing.
              If a Filter condition is specified for the cur-
              rent Browse Window, the Filter expression is
              automatically offered as default for the "FOR"
              condition.

FOR and WHILE clauses: The <F4> key can be pressed while on
    the entry field, to display a picklist of fields from the
    current database. The expression is validated, invalid
    entry is recognized and rejected.
/19 LOCATE Entry
    The LOCATE entry window may be accessed from the Record
Main Menu option, or from the Browse Screen by pressing
<Alt-U>.
    Enter a conditional expression into the entry field,
e.g. "ZIPCODE = '9OO64'". The database will be scanned, start-
ing from the current record, and report "found" at the first
occurrence of a matching record. The Browse Screen will re-
fresh, and the highlight bar will sit on the matching record.
To continue the LOCATE from here, simply press <Alt-U> and
<Enter> again. If no match is found, a "not found" message will
appear, and the highlight bar remains on the previous record.

    LOCATE expression: The <F4> key can be pressed while on the
LOCATE expression entry field, to display a picklist of fields
from the current database. The LOCATE expression is validated,
invalid entry is recognized and rejected.

Note: If a Range/Filter is specified for the Browse Window,
LOCATE will respect the Range and Filter condition and termin-
ate the database scan at the end of the specified Range.
"Found" will NOT be reported if a matching record is located
that does NOT meet the specified Filter condition.
/20 Lock # of Fields
    The Lock # of Fields entry screen may be accessed from the
Fields Main Menu option, or from the Browse Screen by pressing
<Alt-L>.

    Specify the number of data columns on the left side of the
Browse Window to be "locked" or "frozen". If more fields/ex-
pressions are selected than can be simulaneously shown in the
Browse Window, the columns past the right window border can be
scrolled into view by repeatedly pressing the - key. If the
Lock number is 0 (default), columns on the left screen side
will scroll off the screen to make room for the new columns.
Specifying a Lock number greater than 0 allows to lock that
many columns, starting from the leftmost column in the current
field selection, to remain in view while all columns to the
right of the locked columns remain scrollable.
/21 Memo Block Size (Default)
    The Default Memo Block Size is a GlobalSet Pulldown Menu
option. The SIx Driver must be linked, and the setting of
this value applies only to .FPT and .SMT Memo files.

    If a database is created under control of the SIx driver,
Memos created for this database are using the Block size
specified in this setting. The Block size can range from
16 to 1024 Bytes, with 64 offered as a Default value.
/22 Memo Erase
    To delete the data associated with a Memo field or a Flex-
File pointer field, position the Browse cursor over the cell
containing the Memo or FlexFile pointer and press
<Alt-BackSpace>.
    You are prompted whether you wish to Erase the data, or
Cancel the operation. Once Memo or FlexFile data are erased
they can't be restored.
/23 Memo Pack
    A Memo Pack option is available from the AreaSet Pulldown
menu, allowing to Pack an .FPT or .SMT memo file, thus regain-
ing all unused space. A custom Memo Pack Block size can be
specified. The Block size for packing of the Memo can be diff-
erent than the Block size prior to the Memo Pack which is dis-
played as the default value. This option is available for the
SIx Driver only.
/24 FPT / SMT Memo Storage
    When entering Data into an empty FPT or SMT memo field,
a picklist offering six options is displayed:

    - Create Memo: Enter flexible length text into the Memo
      editor. Save with <Ctrl-W>, or Cancel with <Esc>.

    - Import DOS file: Specify the name of a file to store the
      content of into the Memo. The file will be stored as
      Character type, but there is no restriction on the type
      of the file, e.g. binary files or graphic images
      are perfectly legal. The File size can not exceed 64K.

    - Array: Enter the number of elements for the first dimen-
      sion of the Clipper array to be created, and an editable
      Browse window of those elements pops up. From this Array
      Browse window, any number of dimensions can be added.

    - Date, Logical: Enter a single date or logical value to be
      stored in the memo.

    - Numeric: To customize the precision of the number, speci-
      fy number of decimals for entry of the number, then enter
      a single number to be stored in the memo.

/25 Memo Width
    Specify the Memo Display Width for Memo Fields, to allow
proper alignment of text lines when viewing or printing Memo
Fields. Two options are available:

  Default Memo Width (F6 GlobalSet): Initial memo width setting
        when opening a table.

  Memo Width (F5 AreaSet): Workarea specific memo width setting

        Use this option to set the memo width for a specific
        work area after opening the table. When saving your
        environment to a view file, this setting is saved. When
        restoring the view, it will overwrite the Default Memo
        Width setting.

    To view or edit a Memo Field, press <Enter> while the
Browse cursor sits on a Memo Field cell in the Browse Window.
The Memo Field viewing/editing window is sized automatically to
accommodate the current Memo Display Width. If the Memo Display
Width is greater than the maximum window width, the memo text
will scroll left to right inside the Memo window.

    To print Memo Fields, select the Pulldown Menu choice
"List To Print" under the "Command" Main Menu option.
    FlexFile Data: For Display and Printing, character type
FlexFile data are treated like regular Memo Fields.
/26 Next Index Order
    Each Index order can be numbered with a number, according
to its position in the Tag Selection/Information window
(Ctrl-F3).

    To instantly rotate the Order of the controlling index to
the "Next" higher Index, press <Alt-O> from within the Browse
Window. The current row in the Browse Window will remain high-
lighted, but the data rows above and below it will refresh,
reflecting the new index Order.
/27 Next / Previous Select Area
    Each Browse Screen can be numbered with a number between
1 and 7, according to the position of its database in the right
window of Selected Databases in the Database Selection Screen.

    To instantly rotate from one Browse Screen to the "Next" or
"Previous" Browse Screen according to the database position,
press <Alt-N> or <Alt-Minus> from within the Browse Window.

    To instantly access any Browse Screen from any other Browse
Screen, press the <Alt>-key simultaneously with the Select Area
number of the target Browse Screen, e.g. <Alt-1>, <Alt-2> etc.
/28 No Database selected
    This Main Menu option will only appear if NO database file
is open, or NO database file is marked as "current" or "fore-
ground" database.                                             
                                                              
    To change this situation, proceed to the Database Selection
Screen and select a database.                                  
/29 Shared / Exclusive Mode
    The DEFAULT Open Mode for databases can be specified in the
GlobalSet Main Menu option "Default Open Mode". If the Default
Open mode is SHARED, all databases are initially opened as
SHARED. If EXCLUSIVE, all databases are initially opened as
EXCLUSIVE.

NOTE: Default EXCLUSIVE Mode should ONLY be selected on Stand-
      alone Computers, NEVER on Network Workstations. To toggle
      to Default EXCLUSIVE Mode, "Modify" must be ENABLED.

    The CURRENT Open Mode of the current database can be togg-
led from the Database or Index Main Menu options, or by press-
ing <Alt-X> from the Browse Window, the Database Selection
Screen, the Index Selection Screen, the Field Selection Screen,
or the Database Structure Window.

NOTE: For most global file modifications, a database MUST be
      open in EXCLUSIVE mode.
/30 Pack Database
    PACK is a Pulldown Menu item on the "Command" Main Menu
option. It allows to physically remove all records from the
current database which are marked for deletion. After the PACK
operation those records can no longer be retrieved or recalled.

    PACK also recreates any index files of the current database
that are open during the packing.

FlexFile API interface:

    Since PACK does not automatically release FlexFile data
pointed to by FlexFile pointer fields in the deleted records,
use the command option REPLACE to v_delete() the pointer fields
FOR the DELETED() records before issuing the PACK command.

    Note: The database must be open EXCLUSIVE for PACK to be
          available.
/31 Password Entry
    Depending on the way BroPlus was installed entry of a pass-
word may be required to toggle Modify to "ENABLED".

    If Modify is DISABLED, databases will always be opened in
SHARED mode, and EXCLUSIVE mode is not accessible. Also, for
security reasons and to provide Database System Integrity, none
of the Data Modification options of BroPlus are available.

    However, all other options of BroPlus remain accessible:
Database Selection, Index Selection, Field/Expression Selec-
tion, Saving/Restoring of views, and all viewing and printing
options are still available.
/32 Printer Control Codes
    BroPlus allows printing of Current Field Selection, Memo
Fields, and Database Structures. If no Printer Codes are ent-
ered in the starting and ending Printer Control Code entry
fields, Hardcopy is printed in the printer's current default
mode. To customize printer output, enter the control codes used
by your printer into the two entry fields provided.
Use dBase syntax, e.g.:  chr(27)+"(s16H"

Some examples for the HP line of printers:

    Starting Control Codes:

       - Portrait, compressed Print:
                chr(27)+"(s16H"+chr(27)+"&l8D"
       - Landscape, normal Print:
                chr(27)+"&l1O"
       - Landscape, compressed Print:
                chr(27)+"&l1O"+chr(27)+"(s16H"+chr(27)+"&l8D"

    Ending Control Code:  chr(27)+"E"
/00 end of help text broplus2.hlp
